BEGIN TRANSACTION GO ALTER TABLE dbo.gen_ChargesInfo ADD Rate2 numeric(9, 2) NOT NULL CONSTRAINT DF_gen_ChargesInfo_Rate2 DEFAULT 0 GO ALTER TABLE dbo.gen_ChargesInfo ALTER COLUMN CIDString varchar(750) NULL GO ALTER TABLE dbo.gen_ChargesInfo SET (LOCK_ESCALATION = TABLE) GO COMMIT -------------------------------------------------------- BEGIN TRANSACTION GO ALTER TABLE dbo.OrdersDetail ADD TimeIn datetime NULL, TimeOut datetime NULL, Calc numeric(9, 2) NOT NULL CONSTRAINT DF_OrdersDetail_Calc DEFAULT 0 GO ALTER TABLE dbo.OrdersDetail SET (LOCK_ESCALATION = TABLE) GO COMMIT